USE GESTION2
go
IF OBJECT_ID('dbo.WASP_M0016_CANTIDAD') IS NOT NULL
BEGIN
    DROP PROCEDURE dbo.WASP_M0016_CANTIDAD
    IF OBJECT_ID('dbo.WASP_M0016_CANTIDAD') IS NOT NULL
        PRINT '<<< FAILED DROPPING PROCEDURE dbo.WASP_M0016_CANTIDAD >>>'
    ELSE
        PRINT '<<< DROPPED PROCEDURE dbo.WASP_M0016_CANTIDAD >>>'
END
go
SET ANSI_NULLS ON
go
SET QUOTED_IDENTIFIER ON
go
CREATE PROCEDURE WASP_M0016_CANTIDAD 

AS
BEGIN
select count(*) cantidad from sv_seg_vida

END
go
SET ANSI_NULLS OFF
go
SET QUOTED_IDENTIFIER OFF
go
IF OBJECT_ID('dbo.WASP_M0016_CANTIDAD') IS NOT NULL
    PRINT '<<< CREATED PROCEDURE dbo.WASP_M0016_CANTIDAD >>>'
ELSE
    PRINT '<<< FAILED CREATING PROCEDURE dbo.WASP_M0016_CANTIDAD >>>'
go
